Database Indices

You will notice significant performance gains in opening and saving designs if you create the following indices on the PX tables in your database:

Index Name	Table	Fields
PX_USER_USERID_IDX	PROCESS.MM_PX_USER	USER_ID
PX_USER_ROLE_ID_RLID_IDX	PROCESS.MM_PX_USER_ROLE	USER_ID,ROLE_ID
PX_ROLE_RLID_IDX	PROCESS.MM_PX_ROLE	ROLE_ID
PX_NODE_TYPE_ID_IDX	PROCESS.MM_PX_NODE_TYPE	NODE_TYPE_ID
PX_NODE_TYPE_NAME_IDX	PROCESS.MM_PX_NODE_TYPE	name
PX_FILTERS_PRODID_IDX	PROCESS.MM_PX_FILTERS	progid
PX_STATE_STID_IDX	PROCESS.MM_PX_STATE	STATE_ID
PX_STATE_STA_IDX	PROCESS.MM_PX_STATE	STATE
PX_STATE_ROLE_STID_IDX	PROCESS.MM_PX_STATE_ROLE	state_id
PX_SUBTASKS_ID_IDX	PROCESS.MM_PX_SUBTASKS	task_id
PX_SUBTASK_PARAM_STID_IDX	PROCESS.MM_PX_SUBTASKS_PARAMETERS	subtask_id
PX_TRAN_TO_STATE_TRANID_IDX	PROCESS.MM_PX_TRANSITION_TO_STATE	transition_id
PX_TRAN_FROM_STATE_TRANID_IDX	PROCESS.MM_PX_TRANSITION_FROM_STATE	transition_id
PX_TRAN_ROLE_TRANID_IDX	PROCESS.MM_PX_TRANSITION_ROLE	transition_id
PX_HIST_ID_NODETY_NDID_IDX	PROCESS.MM_PX_HISTORY	USER_ID,NODE_TYPE_ID,NODE_ID
MM_MOBILESTATE_NODETYID_IDX	PROCESS.MM_MOBILE_STATE	NODE_TYPE_ID,NODE_ID

SQL Index Statements	Copy Code
create index PX_USER_USERID_IDX on PROCESS.MM_PX_USER(USER_ID); create index PX_USER_ROLE_ID_RLID_IDX on PROCESS.MM_PX_USER_ROLE(USER_ID,ROLE_ID); create index PX_ROLE_RLID_IDX on PROCESS.MM_PX_ROLE(ROLE_ID); create index PX_NODE_TYPE_ID_IDX on PROCESS.MM_PX_NODE_TYPE(NODE_TYPE_ID); create index PX_NODE_TYPE_NAME_IDX on PROCESS.MM_PX_NODE_TYPE(name); create index PX_FILTERS_PRODID_IDX on PROCESS.MM_PX_FILTERS(progid); create index PX_STATE_STID_IDX on PROCESS.MM_PX_STATE(STATE_ID); create index PX_STATE_STA_IDX on PROCESS.MM_PX_STATE(STATE); create index PX_STATE_ROLE_STID_IDX on PROCESS.MM_PX_STATE_ROLE(state_id); create index PX_SUBTASKS_ID_IDX on PROCESS.MM_PX_SUBTASKS(task_id); create index PX_SUBTASK_PARAM_STID_IDX on PROCESS.MM_PX_SUBTASKS_PARAMETERS(subtask_id); create index PX_TRAN_TO_STATE_TRANID_IDX on PROCESS.MM_PX_TRANSITION_TO_STATE(transition_id); create index PX_TRAN_FROM_STATE_TRANID_IDX on PROCESS.MM_PX_TRANSITION_FROM_STATE(transition_id); create index PX_TRAN_ROLE_TRANID_IDX on PROCESS.MM_PX_TRANSITION_ROLE(transition_id); create index PX_HIST_ID_NODETY_NDID_IDX on PROCESS.MM_PX_HISTORY(USER_ID,NODE_TYPE_ID,NODE_ID); create index MM_MOBILESTATE_NODETYID_IDX on PROCESS.MM_MOBILE_STATE(NODE_TYPE_ID,NODE_ID);

SQL Index Statements

Copy Code

create index PX_USER_USERID_IDX on PROCESS.MM_PX_USER(USER_ID);
create index PX_USER_ROLE_ID_RLID_IDX on PROCESS.MM_PX_USER_ROLE(USER_ID,ROLE_ID);
create index PX_ROLE_RLID_IDX on PROCESS.MM_PX_ROLE(ROLE_ID);
create index PX_NODE_TYPE_ID_IDX on PROCESS.MM_PX_NODE_TYPE(NODE_TYPE_ID);
create index PX_NODE_TYPE_NAME_IDX on PROCESS.MM_PX_NODE_TYPE(name);
create index PX_FILTERS_PRODID_IDX on PROCESS.MM_PX_FILTERS(progid);
create index PX_STATE_STID_IDX on PROCESS.MM_PX_STATE(STATE_ID);
create index PX_STATE_STA_IDX on PROCESS.MM_PX_STATE(STATE);
create index PX_STATE_ROLE_STID_IDX on PROCESS.MM_PX_STATE_ROLE(state_id);
create index PX_SUBTASKS_ID_IDX on PROCESS.MM_PX_SUBTASKS(task_id);
create index PX_SUBTASK_PARAM_STID_IDX on PROCESS.MM_PX_SUBTASKS_PARAMETERS(subtask_id);
create index PX_TRAN_TO_STATE_TRANID_IDX on PROCESS.MM_PX_TRANSITION_TO_STATE(transition_id);
create index PX_TRAN_FROM_STATE_TRANID_IDX on PROCESS.MM_PX_TRANSITION_FROM_STATE(transition_id);
create index PX_TRAN_ROLE_TRANID_IDX on PROCESS.MM_PX_TRANSITION_ROLE(transition_id);
create index PX_HIST_ID_NODETY_NDID_IDX on PROCESS.MM_PX_HISTORY(USER_ID,NODE_TYPE_ID,NODE_ID); 
create index MM_MOBILESTATE_NODETYID_IDX on PROCESS.MM_MOBILE_STATE(NODE_TYPE_ID,NODE_ID);